﻿CREATE TABLE [dbo].[Customer_Auditlog] (
    [Id]           INT              IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [CustomerId]   UNIQUEIDENTIFIER NULL,
    [CustomerName] NVARCHAR (150)   NULL,
    [Description]  NVARCHAR (MAX)   NULL,
    [AuditUser]    NVARCHAR (50)    NULL,
    [AuditDate]    DATETIME         NULL,
    [Type]         INT              NULL,
    [CompanyId]    INT              NULL,
    [SalesName]    NVARCHAR (50)    NULL,
    CONSTRAINT [PK_Customer_Auditlog] PRIMARY KEY CLUSTERED ([Id] ASC) WITH (FILLFACTOR = 90)
);


GO
CREATE NONCLUSTERED INDEX [IX_Customer_Auditlog_SalesName]
    ON [dbo].[Customer_Auditlog]([SalesName] ASC) WITH (FILLFACTOR = 90);


GO
CREATE NONCLUSTERED INDEX [IX_Customer_Auditlog_CustomerId]
    ON [dbo].[Customer_Auditlog]([CustomerId] ASC) WITH (FILLFACTOR = 90);

